﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using V5_BLL;
using System.Data;
using V5_DAL.SqlServer;

namespace V5_BLL {
    public class BLLSQL {
        DALSQL dal = new DALSQL();
        /// <summary>
        /// 
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns></returns>
        public DataTable Query(string strSQL) {
            return dal.Query(strSQL);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="what"></param>
        /// <param name="from"></param>
        /// <param name="where"></param>
        /// <param name="orderby"></param>
        /// <param name="limit"></param>
        /// <returns></returns>
        public DataTable Query_By(string what, string from, string where, string orderby, int limit) {
            return dal.Query_By(what, from, where, orderby, limit);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="what"></param>
        /// <param name="from"></param>
        /// <param name="where"></param>
        /// <param name="orderby"></param>
        /// <param name="limit"></param>
        /// <param name="pageIndex"></param>
        /// <param name="indexName"></param>
        /// <param name="UrlFormat"></param>
        /// <returns></returns>
        public DataTable Query_Pager(string what, string from, string where, string orderby, int limit, int pageIndex, string indexName, ref int RecordCount) {
            return dal.Query_Pager(what, from, where, orderby, limit, pageIndex, indexName, ref RecordCount);
        }
    }

}